package com.itheima.mapper;

import com.github.pagehelper.Page;
import com.itheima.pojo.Member;
import com.itheima.pojo.vo.MemberVO;

import java.util.List;
import java.util.Map;

public interface MemberMapper {
    public List<Member> findAll();
    public Page<MemberVO> selectByCondition(String queryString);
    public void add(MemberVO member);
    public void deleteById(Integer id);
    public MemberVO findById(Integer id);
    public MemberVO findByTelephone(String telephone);
    public void edit(Member member);
    public Integer findMemberCountBeforeDate(String date);
    public Integer findMemberCountByDate(String date);
    public Integer findMemberCountAfterDate(String date);
    public Integer findMemberTotalCount();

    List<Integer> findMemberCountBeforeDate_2(List<String> months);

    List<Map<String, Object>> getMemberReport();
}
